UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AMEiXSl2HoZMDPzBdAUjXjW916F59evtvTpyBNKzF04='
WHERE
key_id = '4823e57a676f9220a9642d862aae763ddd72d718e2dfbebc52d67d9d7cde823a'
AND (
token = 'AMEiXSl2HoZMDPzBdAUjXjW916F59evtvTpyBNKzF04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)