UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bGtKqgSXM6y4kG+ebppcDXruSks6X9rWZCeDfx92aFs='
WHERE
key_id = 'a5d423f574fceccc5c2c1e70d3f70c601f3ed9f49c4ed905348a7815576e2012'
AND (
token = 'bGtKqgSXM6y4kG+ebppcDXruSks6X9rWZCeDfx92aFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)