UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'djL3s67d47uzQuN3DJ6k6iHGu9Gtcmh5+PapgBVl+eE='
WHERE
key_id = 'a031d1904316075f94f00e8d75812a1b0b591dad4173f3bdf204cc45032076e3'
AND (
token = 'djL3s67d47uzQuN3DJ6k6iHGu9Gtcmh5+PapgBVl+eE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)